USE [Escuela]
GO

/****** Object:  StoredProcedure [dbo].[coop_materia_GetOne_by_name]    Script Date: 08/21/2013 18:34:07 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


--------------------------------------------------
-- Author: Cooperator Modeler, Version 1.3.0.1133
-- Created: 23/07/2013 - 06:09 p.m.
--------------------------------------------------
ALTER PROCEDURE [dbo].[coop_materia_GetOne_by_name]

@nombre varchar(255)

AS

SELECT 

[id],
[activo],
[cantidad_horas],
[descripcion],
[nombre]

FROM [dbo].[materia]
WHERE 

[nombre] = @nombre

GO

